set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [GOOGLECODERS].[BeneficiariosGetByRazonSocial]
	@RazonSocial varchar(255)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT
		IdBeneficiario,
		RazonSocial,
		DirCalle,
		DirNro,
		DirPiso,
		DirDepto,
		IdRubro,
		Habilitado
	FROM Beneficiarios
	WHERE
		RazonSocial = @RazonSocial
END